﻿CREATE TRIGGER RolesPermissions_Tracking_Update
ON [dbo].[RolesPermissions] 
AFTER Update
AS 
BEGIN
	UPDATE Sync.RolesPermissions_Tracking 
	SET LastUpdatedDate  = getdate()
    FROM Sync.RolesPermissions_Tracking s JOIN INSERTED i
    ON s.PermissionID = i.PermissionID AND s.RoleID = i.RoleID
END





